Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TenderLineItem(TR_LTM_TND) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | TenderLineItem(TR_LTM_TND) |
DenominationID (FK)(PK) | An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, etc. | ID_DNM | Identity | integer | Denomination(CO_DNM) |
ISOCurrencyCode (FK)(PK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | Denomination(CO_DNM) |
DenominationQuantity | The number of the Denomination units used by the TenderLineItem. | QY_DNM | Quantity | DECIMAL(9,3) | |